package mapper;

import model.vo.RegistryVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface RegistryMapper {

    @Select("select r.id rid,p.name pname,p.sex,p.id_card card,d.name dname,u.account doctor,r.registry_time rTime,r.created_time cTime,r.status rStatus from registry r join patient p on r.patient_id = p.id\n" +
            "join schedule s on r.schedule_id = s.id\n" +
            "join sys_users u on u.id=s.user_id\n" +
            "join department d on r.department_id = d.id")
    List<RegistryVO> findAll();
}
